Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	10649317
Missing cells	13495801
Missing cells (%)	7.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.4 GiB
Average record size in memory	144.0 B

Variable types

Numeric	7
Categorical	11

Alerts

`start_time` has a high cardinality: 8706 distinct values	High cardinality
`blueprint` has a high cardinality: 441 distinct values	High cardinality
`login` has a high cardinality: 1414 distinct values	High cardinality
`position_x` is highly correlated with `map_width` and 1 other fields	High correlation
`position_y` is highly correlated with `map_width` and 1 other fields	High correlation
`map_width` is highly correlated with `position_x` and 2 other fields	High correlation
`map_height` is highly correlated with `position_x` and 2 other fields	High correlation
`position_x` is highly correlated with `map_width` and 1 other fields	High correlation
`position_y` is highly correlated with `map_width` and 1 other fields	High correlation
`map_width` is highly correlated with `position_x` and 2 other fields	High correlation
`map_height` is highly correlated with `position_x` and 2 other fields	High correlation
`map_width` is highly correlated with `map_height`	High correlation
`map_height` is highly correlated with `map_width`	High correlation
`map_name` is highly correlated with `map_height` and 2 other fields	High correlation
`map_height` is highly correlated with `map_name` and 2 other fields	High correlation
`map_width` is highly correlated with `map_name` and 2 other fields	High correlation
`map_thumbnail` is highly correlated with `map_name` and 2 other fields	High correlation
`position_x` is highly correlated with `position_y` and 4 other fields	High correlation
`position_y` is highly correlated with `position_x` and 4 other fields	High correlation
`faf_player_id` is highly correlated with `rating`	High correlation
`rating` is highly correlated with `faf_player_id` and 2 other fields	High correlation
`map_name` is highly correlated with `position_x` and 5 other fields	High correlation
`map_thumbnail` is highly correlated with `position_x` and 5 other fields	High correlation
`map_width` is highly correlated with `position_x` and 4 other fields	High correlation
`map_height` is highly correlated with `position_x` and 4 other fields	High correlation
`blueprint` has 7697205 (72.3%) missing values	Missing
`position_x` has 2899298 (27.2%) missing values	Missing
`position_y` has 2899298 (27.2%) missing values	Missing
`units_number` has 264488 (2.5%) zeros	Zeros
`rating` has 115913 (1.1%) zeros	Zeros

Reproduction

Analysis started	2022-07-28 03:07:39.823401
Analysis finished	2022-07-28 03:19:23.622767
Duration	11 minutes and 43.8 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

id
Real number (ℝ_≥0)

Distinct	8860
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16572264.96

Minimum	16462952
Maximum	16683253
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	81.2 MiB

Quantile statistics

Minimum	16462952
5-th percentile	16473326
Q1	16517949
median	16570283
Q3	16627127
95-th percentile	16672501
Maximum	16683253
Range	220301
Interquartile range (IQR)	109178

Descriptive statistics

Standard deviation	63479.47416
Coefficient of variation (CV)	0.003830464593
Kurtosis	-1.187056363
Mean	16572264.96
Median Absolute Deviation (MAD)	54673
Skewness	0.04073272443
Sum	1.76483303 × 10¹⁴
Variance	4029643639
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16613628	8336	0.1%
16577001	8179	0.1%
16559443	8156	0.1%
16651832	7853	0.1%
16511210	7391	0.1%
16629045	7305	0.1%
16548106	7282	0.1%
16661916	7054	0.1%
16603165	6942	0.1%
16644387	6705	0.1%
Other values (8850)	10574114	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
16462952	973	< 0.1%
16462991	2473	< 0.1%
16463034	449	< 0.1%
16463202	1005	< 0.1%
16463213	2075	< 0.1%
16463255	1474	< 0.1%
16463256	1255	< 0.1%
16463288	1608	< 0.1%
16463417	1585	< 0.1%
16463462	986	< 0.1%

Value	Count	Frequency (%)
16683253	6583	0.1%
16683220	476	< 0.1%
16683169	1443	< 0.1%
16683156	898	< 0.1%
16683099	391	< 0.1%
16683084	236	< 0.1%
16683063	3469	< 0.1%
16683062	2377	< 0.1%
16683033	2435	< 0.1%
16683028	1288	< 0.1%

start_time
Categorical

HIGH CARDINALITY

Distinct	8706
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	81.2 MiB

2022-03-17 20:34:03 UTC	10518
2022-03-22 18:46:46 UTC	8336
2022-03-14 22:42:58 UTC	8156
2022-03-16 22:34:05 UTC	7884
2022-03-27 16:46:40 UTC	7853
Other values (8701)	10606570

Length

Max length	23
Median length	23
Mean length	23
Min length	23

Characters and Unicode

Total characters	244934291
Distinct characters	16
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	172 ?
Unique (%)	< 0.1%

Sample

1st row	2022-03-25 09:22:13 UTC
2nd row	2022-03-11 20:19:06 UTC
3rd row	2022-03-14 00:27:49 UTC
4th row	2022-03-14 00:27:49 UTC
5th row	2022-03-27 14:52:40 UTC

Common Values

Value	Count	Frequency (%)
2022-03-17 20:34:03 UTC	10518	0.1%
2022-03-22 18:46:46 UTC	8336	0.1%
2022-03-14 22:42:58 UTC	8156	0.1%
2022-03-16 22:34:05 UTC	7884	0.1%
2022-03-27 16:46:40 UTC	7853	0.1%
2022-03-08 04:19:04 UTC	7391	0.1%
2022-03-25 00:37:10 UTC	7305	0.1%
2022-03-13 12:37:18 UTC	7282	0.1%
2022-03-28 21:46:49 UTC	7054	0.1%
2022-03-21 03:28:33 UTC	6942	0.1%
Other values (8696)	10570596	99.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
utc	10649317	33.3%
2022-03-13	462737	1.4%
2022-03-12	457122	1.4%
2022-03-25	415463	1.3%
2022-03-27	412049	1.3%
2022-03-07	408362	1.3%
2022-03-06	395657	1.2%
2022-03-19	394976	1.2%
2022-03-28	380870	1.2%
2022-03-24	366422	1.1%
Other values (7657)	17604976	55.1%

Most occurring characters

Value	Count	Frequency (%)
2	44607209	18.2%
0	35710181	14.6%
-	21298634	8.7%
	21298634	8.7%
:	21298634	8.7%
3	18321225	7.5%
1	18312947	7.5%
U	10649317	4.3%
T	10649317	4.3%
C	10649317	4.3%
Other values (6)	32138876	13.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	149090438	60.9%
Uppercase Letter	31947951	13.0%
Dash Punctuation	21298634	8.7%
Space Separator	21298634	8.7%
Other Punctuation	21298634	8.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	44607209	29.9%
0	35710181	24.0%
3	18321225	12.3%
1	18312947	12.3%
4	7874342	5.3%
5	7601750	5.1%
9	4314105	2.9%
7	4150981	2.8%
8	4110005	2.8%
6	4087693	2.7%

Uppercase Letter

Value	Count	Frequency (%)
U	10649317	33.3%
T	10649317	33.3%
C	10649317	33.3%

Dash Punctuation

Value	Count	Frequency (%)
-	21298634	100.0%

Space Separator

Value	Count	Frequency (%)
	21298634	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	21298634	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	212986340	87.0%
Latin	31947951	13.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	44607209	20.9%
0	35710181	16.8%
-	21298634	10.0%
	21298634	10.0%
:	21298634	10.0%
3	18321225	8.6%
1	18312947	8.6%
4	7874342	3.7%
5	7601750	3.6%
9	4314105	2.0%
Other values (3)	12348679	5.8%

Latin

Value	Count	Frequency (%)
U	10649317	33.3%
T	10649317	33.3%
C	10649317	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	244934291	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	44607209	18.2%
0	35710181	14.6%
-	21298634	8.7%
	21298634	8.7%
:	21298634	8.7%
3	18321225	7.5%
1	18312947	7.5%
U	10649317	4.3%
T	10649317	4.3%
C	10649317	4.3%
Other values (6)	32138876	13.1%

offset_ms
Real number (ℝ_≥0)

Distinct	59864
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	793221.0723

Minimum	0
Maximum	8623200
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	81.2 MiB

Quantile statistics

Minimum	0
5-th percentile	73900
Q1	311800
median	604300
Q3	1052200
95-th percentile	2179000
Maximum	8623200
Range	8623200
Interquartile range (IQR)	740400

Descriptive statistics

Standard deviation	707399.6088
Coefficient of variation (CV)	0.8918063747
Kurtosis	7.652590491
Mean	793221.0723
Median Absolute Deviation (MAD)	342400
Skewness	2.135964824
Sum	8.44726265 × 10¹²
Variance	5.004142065 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
317500	1076	< 0.1%
87800	1075	< 0.1%
324900	1057	< 0.1%
360600	1055	< 0.1%
316800	1054	< 0.1%
87500	1050	< 0.1%
87300	1041	< 0.1%
318300	1040	< 0.1%
313000	1037	< 0.1%
87400	1037	< 0.1%
Other values (59854)	10638795	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2	< 0.1%
1800	1	< 0.1%
1900	1	< 0.1%
2000	101	< 0.1%
2100	11	< 0.1%
2200	9	< 0.1%
2300	15	< 0.1%
2400	17	< 0.1%
2500	16	< 0.1%
2600	26	< 0.1%

Value	Count	Frequency (%)
8623200	1	< 0.1%
8618100	1	< 0.1%
8606600	1	< 0.1%
8600800	1	< 0.1%
8600500	1	< 0.1%
8599600	1	< 0.1%
8599000	1	< 0.1%
8598600	1	< 0.1%
8597500	1	< 0.1%
8592800	1	< 0.1%

player
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	81.2 MiB

1	5358541
0	5290776

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10649317
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	0
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
1	5358541	50.3%
0	5290776	49.7%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
1	5358541	50.3%
0	5290776	49.7%

Most occurring characters

Value	Count	Frequency (%)
1	5358541	50.3%
0	5290776	49.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10649317	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	5358541	50.3%
0	5290776	49.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	10649317	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	5358541	50.3%
0	5290776	49.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10649317	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	5358541	50.3%
0	5290776	49.7%

type
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	81.2 MiB

issue	10276905
factory_issue	372412

Length

Max length	13
Median length	5
Mean length	5.279764045
Min length	5

Characters and Unicode

Total characters	56225881
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	issue
2nd row	issue
3rd row	issue
4th row	issue
5th row	issue

Common Values

Value	Count	Frequency (%)
issue	10276905	96.5%
factory_issue	372412	3.5%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
issue	10276905	96.5%
factory_issue	372412	3.5%

Most occurring characters

Value	Count	Frequency (%)
s	21298634	37.9%
i	10649317	18.9%
u	10649317	18.9%
e	10649317	18.9%
f	372412	0.7%
a	372412	0.7%
c	372412	0.7%
t	372412	0.7%
o	372412	0.7%
r	372412	0.7%
Other values (2)	744824	1.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	55853469	99.3%
Connector Punctuation	372412	0.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	21298634	38.1%
i	10649317	19.1%
u	10649317	19.1%
e	10649317	19.1%
f	372412	0.7%
a	372412	0.7%
c	372412	0.7%
t	372412	0.7%
o	372412	0.7%
r	372412	0.7%

Connector Punctuation

Value	Count	Frequency (%)
_	372412	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	55853469	99.3%
Common	372412	0.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	21298634	38.1%
i	10649317	19.1%
u	10649317	19.1%
e	10649317	19.1%
f	372412	0.7%
a	372412	0.7%
c	372412	0.7%
t	372412	0.7%
o	372412	0.7%
r	372412	0.7%

Common

Value	Count	Frequency (%)
_	372412	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	56225881	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	21298634	37.9%
i	10649317	18.9%
u	10649317	18.9%
e	10649317	18.9%
f	372412	0.7%
a	372412	0.7%
c	372412	0.7%
t	372412	0.7%
o	372412	0.7%
r	372412	0.7%
Other values (2)	744824	1.3%

units_number
Real number (ℝ_≥0)

ZEROS

Distinct	498
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.795839583

Minimum	0
Maximum	1158
Zeros	264488
Zeros (%)	2.5%
Negative	0
Negative (%)	0.0%
Memory size	81.2 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	6
95-th percentile	32
Maximum	1158
Range	1158
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	15.11830828
Coefficient of variation (CV)	2.224641724
Kurtosis	187.8420486
Mean	6.795839583
Median Absolute Deviation (MAD)	0
Skewness	7.802602789
Sum	72371050
Variance	228.5632454
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	5841480	54.9%
2	706871	6.6%
3	474870	4.5%
4	374277	3.5%
5	299445	2.8%
0	264488	2.5%
6	243910	2.3%
7	200120	1.9%
8	174235	1.6%
9	149773	1.4%
Other values (488)	1919848	18.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	264488	2.5%
1	5841480	54.9%
2	706871	6.6%
3	474870	4.5%
4	374277	3.5%
5	299445	2.8%
6	243910	2.3%
7	200120	1.9%
8	174235	1.6%
9	149773	1.4%

Value	Count	Frequency (%)
1158	1	< 0.1%
1030	1	< 0.1%
1025	1	< 0.1%
1024	2	< 0.1%
1013	1	< 0.1%
1008	1	< 0.1%
998	1	< 0.1%
976	1	< 0.1%
966	1	< 0.1%
958	1	< 0.1%

blueprint
Categorical

HIGH CARDINALITY
MISSING

Distinct	441
Distinct (%)	< 0.1%
Missing	7697205
Missing (%)	72.3%
Memory size	81.2 MiB

ueb1103	220610
urb1103	166992
url0107	103988
uel0201	103376
xsb1103	92688
Other values (436)	2264458

Length

Max length	22
Median length	7
Mean length	7.003478527
Min length	7

Characters and Unicode

Total characters	20675053
Distinct characters	33
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7 ?
Unique (%)	< 0.1%

Sample

1st row	ueb1103
2nd row	urb0102
3rd row	ueb1103
4th row	ueb1202
5th row	urb1101

Common Values

Value	Count	Frequency (%)
ueb1103	220610	2.1%
urb1103	166992	1.6%
url0107	103988	1.0%
uel0201	103376	1.0%
xsb1103	92688	0.9%
uel0105	88480	0.8%
ueb0101	79580	0.7%
url0105	70815	0.7%
uab1103	69880	0.7%
ueb1101	68876	0.6%
Other values (431)	1886827	17.7%
(Missing)	7697205	72.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ueb1103	220610	7.5%
urb1103	166992	5.7%
url0107	103988	3.5%
uel0201	103376	3.5%
xsb1103	92688	3.1%
uel0105	88480	3.0%
ueb0101	79580	2.7%
url0105	70815	2.4%
uab1103	69880	2.4%
ueb1101	68876	2.3%
Other values (431)	1886827	63.9%

Most occurring characters

Value	Count	Frequency (%)
0	4495056	21.7%
1	4079725	19.7%
u	2386985	11.5%
b	1729385	8.4%
2	1280276	6.2%
e	1194822	5.8%
3	1051480	5.1%
l	977823	4.7%
r	928906	4.5%
a	587924	2.8%
Other values (23)	1962671	9.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	11803363	57.1%
Lowercase Letter	8869675	42.9%
Connector Punctuation	2015	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
u	2386985	26.9%
b	1729385	19.5%
e	1194822	13.5%
l	977823	11.0%
r	928906	10.5%
a	587924	6.6%
x	498342	5.6%
s	489046	5.5%
z	34295	0.4%
d	32585	0.4%
Other values (12)	9562	0.1%

Decimal Number

Value	Count	Frequency (%)
0	4495056	38.1%
1	4079725	34.6%
2	1280276	10.8%
3	1051480	8.9%
5	374115	3.2%
4	237862	2.0%
7	117171	1.0%
6	73256	0.6%
9	49397	0.4%
8	45025	0.4%

Connector Punctuation

Value	Count	Frequency (%)
_	2015	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	11805378	57.1%
Latin	8869675	42.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
u	2386985	26.9%
b	1729385	19.5%
e	1194822	13.5%
l	977823	11.0%
r	928906	10.5%
a	587924	6.6%
x	498342	5.6%
s	489046	5.5%
z	34295	0.4%
d	32585	0.4%
Other values (12)	9562	0.1%

Common

Value	Count	Frequency (%)
0	4495056	38.1%
1	4079725	34.6%
2	1280276	10.8%
3	1051480	8.9%
5	374115	3.2%
4	237862	2.0%
7	117171	1.0%
6	73256	0.6%
9	49397	0.4%
8	45025	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20675053	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	4495056	21.7%
1	4079725	19.7%
u	2386985	11.5%
b	1729385	8.4%
2	1280276	6.2%
e	1194822	5.8%
3	1051480	5.1%
l	977823	4.7%
r	928906	4.5%
a	587924	2.8%
Other values (23)	1962671	9.5%

position_x
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	5108902
Distinct (%)	65.9%
Missing	2899298
Missing (%)	27.2%
Infinite	0
Infinite (%)	0.0%
Mean	260.7909918

Minimum	-0.9940414429
Maximum	1023.993225
Zeros	2
Zeros (%)	< 0.1%
Negative	146
Negative (%)	< 0.1%
Memory size	81.2 MiB

Quantile statistics

Minimum	-0.9940414429
5-th percentile	51.17489624
Q1	134.0476532
median	234.9521484
Q3	361.5
95-th percentile	552.5
Maximum	1023.993225
Range	1024.987267
Interquartile range (IQR)	227.4523468

Descriptive statistics

Standard deviation	163.8237293
Coefficient of variation (CV)	0.6281801689
Kurtosis	1.466136818
Mean	260.7909918
Median Absolute Deviation (MAD)	110.216095
Skewness	1.052628312
Sum	2021135141
Variance	26838.21427
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
246.5	10201	0.1%
108.5	10086	0.1%
72.5	9623	0.1%
128.5	9621	0.1%
439.5	9502	0.1%
446.5	9499	0.1%
264.5	9280	0.1%
261.5	9152	0.1%
188.5	8536	0.1%
75.5	8431	0.1%
Other values (5108892)	7656088	71.9%
(Missing)	2899298	27.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.9940414429	1	< 0.1%
-0.9929885864	1	< 0.1%
-0.9901046753	1	< 0.1%
-0.986328125	1	< 0.1%
-0.9828491211	1	< 0.1%
-0.9794921875	1	< 0.1%
-0.9765396118	1	< 0.1%
-0.9698867798	1	< 0.1%
-0.9667205811	1	< 0.1%
-0.955871582	1	< 0.1%

Value	Count	Frequency (%)
1023.993225	1	< 0.1%
1023.551025	1	< 0.1%
1023.432007	1	< 0.1%
1023.328552	1	< 0.1%
1023.279846	1	< 0.1%
1023.264771	1	< 0.1%
1023.249878	1	< 0.1%
1023.072083	1	< 0.1%
1022.895081	1	< 0.1%
1022.797363	1	< 0.1%

position_y
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	5030610
Distinct (%)	64.9%
Missing	2899298
Missing (%)	27.2%
Infinite	0
Infinite (%)	0.0%
Mean	266.1674053

Minimum	-0.9997253418
Maximum	1023.999512
Zeros	2
Zeros (%)	< 0.1%
Negative	63
Negative (%)	< 0.1%
Memory size	81.2 MiB

Quantile statistics

Minimum	-0.9997253418
5-th percentile	50.10795975
Q1	136.6473618
median	236.6968079
Q3	371.4170532
95-th percentile	572.1413269
Maximum	1023.999512
Range	1024.999237
Interquartile range (IQR)	234.7696915

Descriptive statistics

Standard deviation	167.4089029
Coefficient of variation (CV)	0.6289609456
Kurtosis	1.178209145
Mean	266.1674053
Median Absolute Deviation (MAD)	116.2043991
Skewness	0.9770891561
Sum	2062802448
Variance	28025.74078
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
222.5	11466	0.1%
70.5	9588	0.1%
421.5	9224	0.1%
400.5	9145	0.1%
62.5	8899	0.1%
88.5	8698	0.1%
449.5	8574	0.1%
357.5	8092	0.1%
45.5	8007	0.1%
142.5	7889	0.1%
Other values (5030600)	7660437	71.9%
(Missing)	2899298	27.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.9997253418	1	< 0.1%
-0.9790802002	1	< 0.1%
-0.9571762085	1	< 0.1%
-0.9567565918	1	< 0.1%
-0.9556732178	1	< 0.1%
-0.952507019	3	< 0.1%
-0.9476928711	1	< 0.1%
-0.9473114014	1	< 0.1%
-0.8904953003	3	< 0.1%
-0.8282012939	1	< 0.1%

Value	Count	Frequency (%)
1023.999512	1	< 0.1%
1023.849121	1	< 0.1%
1023.737061	1	< 0.1%
1023.467957	1	< 0.1%
1023.287659	1	< 0.1%
1023.134583	1	< 0.1%
1023.000122	1	< 0.1%
1022.963135	1	< 0.1%
1022.824829	1	< 0.1%
1022.764648	1	< 0.1%

command_name
Categorical

Distinct	30
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	81.2 MiB

Move	5413099
BuildMobile	1305033
BuildFactory	1218157
Attack	645324
Reclaim	577775
Other values (25)	1489929

Length

Max length	28
Median length	4
Mean length	6.653150244
Min length	4

Characters and Unicode

Total characters	70851506
Distinct characters	37
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	TransportUnloadSpecificUnits
2nd row	FormMove
3rd row	Stop
4th row	Stop
5th row	TransportUnloadUnits

Common Values

Value	Count	Frequency (%)
Move	5413099	50.8%
BuildMobile	1305033	12.3%
BuildFactory	1218157	11.4%
Attack	645324	6.1%
Reclaim	577775	5.4%
Guard	421514	4.0%
AggressiveMove	376746	3.5%
Patrol	253653	2.4%
Upgrade	158120	1.5%
Repair	70532	0.7%
Other values (20)	209364	2.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
move	5413099	50.8%
buildmobile	1305033	12.3%
buildfactory	1218157	11.4%
attack	645324	6.1%
reclaim	577775	5.4%
guard	421514	4.0%
aggressivemove	376746	3.5%
patrol	253653	2.4%
upgrade	158120	1.5%
repair	70532	0.7%
Other values (20)	209364	2.0%

Most occurring characters

Value	Count	Frequency (%)
o	8768166	12.4%
e	8752204	12.4%
M	7135400	10.1%
v	6226308	8.8%
i	4967748	7.0%
l	4687487	6.6%
a	3454627	4.9%
d	3135999	4.4%
u	2954994	4.2%
t	2953815	4.2%
Other values (27)	17814758	25.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	57169073	80.7%
Uppercase Letter	13682433	19.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	8768166	15.3%
e	8752204	15.3%
v	6226308	10.9%
i	4967748	8.7%
l	4687487	8.2%
a	3454627	6.0%
d	3135999	5.5%
u	2954994	5.2%
t	2953815	5.2%
r	2696328	4.7%
Other values (11)	8571397	15.0%

Uppercase Letter

Value	Count	Frequency (%)
M	7135400	52.2%
B	2523190	18.4%
F	1261203	9.2%
A	1032032	7.5%
R	649537	4.7%
G	421514	3.1%
P	253653	1.9%
U	207275	1.5%
S	107006	0.8%
T	44629	0.3%
Other values (6)	46994	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	70851506	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	8768166	12.4%
e	8752204	12.4%
M	7135400	10.1%
v	6226308	8.8%
i	4967748	7.0%
l	4687487	6.6%
a	3454627	4.9%
d	3135999	4.4%
u	2954994	4.2%
t	2953815	4.2%
Other values (27)	17814758	25.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	70851506	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	8768166	12.4%
e	8752204	12.4%
M	7135400	10.1%
v	6226308	8.8%
i	4967748	7.0%
l	4687487	6.6%
a	3454627	4.9%
d	3135999	4.4%
u	2954994	4.2%
t	2953815	4.2%
Other values (27)	17814758	25.1%

faf_player_id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1398
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	234940.1606

Minimum	145
Maximum	440191
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	81.2 MiB

Quantile statistics

Minimum	145
5-th percentile	14492
Q1	82362
median	250231
Q3	380088
95-th percentile	436101
Maximum	440191
Range	440046
Interquartile range (IQR)	297726

Descriptive statistics

Standard deviation	153256.8476
Coefficient of variation (CV)	0.652322903
Kurtosis	-1.517765668
Mean	234940.1606
Median Absolute Deviation (MAD)	142769
Skewness	-0.1468795764
Sum	2.501952246 × 10¹²
Variance	2.348766133 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
62848	220873	2.1%
2642	160077	1.5%
131692	149540	1.4%
19844	136953	1.3%
38512	127130	1.2%
366310	122426	1.1%
403743	121426	1.1%
241137	107916	1.0%
287686	107556	1.0%
378017	97289	0.9%
Other values (1388)	9298131	87.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
145	908	< 0.1%
259	74665	0.7%
434	15895	0.1%
435	35831	0.3%
606	7997	0.1%
648	27131	0.3%
674	1028	< 0.1%
900	551	< 0.1%
1294	22152	0.2%
1297	1930	< 0.1%

Value	Count	Frequency (%)
440191	280	< 0.1%
440181	390	< 0.1%
440128	3550	< 0.1%
440019	157	< 0.1%
440001	125	< 0.1%
439974	207	< 0.1%
439927	118	< 0.1%
439900	381	< 0.1%
439899	581	< 0.1%
439887	14627	0.1%

login
Categorical

HIGH CARDINALITY

Distinct	1414
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	81.2 MiB

Chenbro101	220873
nemir	160077
Yew	149540
Electrician	136953
Aldarion	127130
Other values (1409)	9854744

Length

Max length	16
Median length	12
Mean length	8.66422579
Min length	2

Characters and Unicode

Total characters	92268087
Distinct characters	64
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6 ?
Unique (%)	< 0.1%

Sample

1st row	Exselsior
2nd row	StormLantern
3rd row	Saphed
4th row	demonstreamer666
5th row	ZXCCURSED

Common Values

Value	Count	Frequency (%)
Chenbro101	220873	2.1%
nemir	160077	1.5%
Yew	149540	1.4%
Electrician	136953	1.3%
Aldarion	127130	1.2%
Knockout01	122426	1.1%
indicator2020	121426	1.1%
LaissezFairy	107916	1.0%
demonstreamer666	107556	1.0%
Pryanichek	97289	0.9%
Other values (1404)	9298131	87.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
chenbro101	220873	2.1%
nemir	160077	1.5%
yew	149540	1.4%
electrician	136953	1.3%
aldarion	127130	1.2%
knockout01	122426	1.1%
indicator2020	121426	1.1%
laissezfairy	107916	1.0%
demonstreamer666	107556	1.0%
pryanichek	97289	0.9%
Other values (1404)	9298131	87.3%

Most occurring characters

Value	Count	Frequency (%)
a	8302164	9.0%
e	7096729	7.7%
r	5737422	6.2%
o	5418538	5.9%
n	5270612	5.7%
i	5229546	5.7%
t	3826103	4.1%
l	3354663	3.6%
s	3354229	3.6%
m	2442303	2.6%
Other values (54)	42235778	45.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	69738624	75.6%
Uppercase Letter	15528918	16.8%
Decimal Number	5375942	5.8%
Connector Punctuation	1393922	1.5%
Dash Punctuation	230681	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	8302164	11.9%
e	7096729	10.2%
r	5737422	8.2%
o	5418538	7.8%
n	5270612	7.6%
i	5229546	7.5%
t	3826103	5.5%
l	3354663	4.8%
s	3354229	4.8%
m	2442303	3.5%
Other values (16)	19706315	28.3%

Uppercase Letter

Value	Count	Frequency (%)
S	1340547	8.6%
A	1071767	6.9%
C	1044637	6.7%
T	1005884	6.5%
R	973127	6.3%
D	853719	5.5%
B	786928	5.1%
N	777877	5.0%
P	762160	4.9%
L	721551	4.6%
Other values (16)	6190721	39.9%

Decimal Number

Value	Count	Frequency (%)
1	1350216	25.1%
0	1164595	21.7%
2	752828	14.0%
6	540225	10.0%
3	326720	6.1%
4	303194	5.6%
9	272822	5.1%
7	253955	4.7%
8	237520	4.4%
5	173867	3.2%

Connector Punctuation

Value	Count	Frequency (%)
_	1393922	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	230681	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	85267542	92.4%
Common	7000545	7.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	8302164	9.7%
e	7096729	8.3%
r	5737422	6.7%
o	5418538	6.4%
n	5270612	6.2%
i	5229546	6.1%
t	3826103	4.5%
l	3354663	3.9%
s	3354229	3.9%
m	2442303	2.9%
Other values (42)	35235233	41.3%

Common

Value	Count	Frequency (%)
_	1393922	19.9%
1	1350216	19.3%
0	1164595	16.6%
2	752828	10.8%
6	540225	7.7%
3	326720	4.7%
4	303194	4.3%
9	272822	3.9%
7	253955	3.6%
8	237520	3.4%
Other values (2)	404548	5.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	92268087	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	8302164	9.0%
e	7096729	7.7%
r	5737422	6.2%
o	5418538	5.9%
n	5270612	5.7%
i	5229546	5.7%
t	3826103	4.1%
l	3354663	3.6%
s	3354229	3.6%
m	2442303	2.6%
Other values (54)	42235778	45.8%

rating
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	2277
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	793.7289536

Minimum	-698
Maximum	2346
Zeros	115913
Zeros (%)	1.1%
Negative	395127
Negative (%)	3.7%
Memory size	81.2 MiB

Quantile statistics

Minimum	-698
5-th percentile	11
Q1	426
median	738
Q3	1188
95-th percentile	1639
Maximum	2346
Range	3044
Interquartile range (IQR)	762

Descriptive statistics

Standard deviation	506.0873452
Coefficient of variation (CV)	0.6376072624
Kurtosis	-0.411666717
Mean	793.7289536
Median Absolute Deviation (MAD)	363
Skewness	0.2744341983
Sum	8452671239
Variance	256124.4009
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	115913	1.1%
1248	19366	0.2%
1471	19153	0.2%
477	18004	0.2%
774	17199	0.2%
1250	16560	0.2%
474	15973	0.1%
1240	15780	0.1%
982	15457	0.1%
556	15310	0.1%
Other values (2267)	10380602	97.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-698	161	< 0.1%
-682	368	< 0.1%
-545	799	< 0.1%
-535	213	< 0.1%
-534	837	< 0.1%
-523	72	< 0.1%
-508	48	< 0.1%
-503	271	< 0.1%
-497	24	< 0.1%
-492	385	< 0.1%

Value	Count	Frequency (%)
2346	432	< 0.1%
2338	566	< 0.1%
2334	534	< 0.1%
2328	1037	< 0.1%
2327	564	< 0.1%
2322	653	< 0.1%
2320	694	< 0.1%
2314	1271	< 0.1%
2305	781	< 0.1%
2289	1077	< 0.1%

faction
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	81.2 MiB

UEF	4257355
Cybran	3151404
Seraphim	1814377
Aeon	1426181

Length

Max length	8
Median length	6
Mean length	4.873573488
Min length	3

Characters and Unicode

Total characters	51900229
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Cybran
2nd row	Cybran
3rd row	Seraphim
4th row	Cybran
5th row	Seraphim

Common Values

Value	Count	Frequency (%)
UEF	4257355	40.0%
Cybran	3151404	29.6%
Seraphim	1814377	17.0%
Aeon	1426181	13.4%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
uef	4257355	40.0%
cybran	3151404	29.6%
seraphim	1814377	17.0%
aeon	1426181	13.4%

Most occurring characters

Value	Count	Frequency (%)
r	4965781	9.6%
a	4965781	9.6%
n	4577585	8.8%
E	4257355	8.2%
U	4257355	8.2%
F	4257355	8.2%
e	3240558	6.2%
b	3151404	6.1%
y	3151404	6.1%
C	3151404	6.1%
Other values (7)	11924247	23.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	32736202	63.1%
Uppercase Letter	19164027	36.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	4965781	15.2%
a	4965781	15.2%
n	4577585	14.0%
e	3240558	9.9%
b	3151404	9.6%
y	3151404	9.6%
p	1814377	5.5%
h	1814377	5.5%
i	1814377	5.5%
m	1814377	5.5%

Uppercase Letter

Value	Count	Frequency (%)
E	4257355	22.2%
U	4257355	22.2%
F	4257355	22.2%
C	3151404	16.4%
S	1814377	9.5%
A	1426181	7.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	51900229	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	4965781	9.6%
a	4965781	9.6%
n	4577585	8.8%
E	4257355	8.2%
U	4257355	8.2%
F	4257355	8.2%
e	3240558	6.2%
b	3151404	6.1%
y	3151404	6.1%
C	3151404	6.1%
Other values (7)	11924247	23.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	51900229	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	4965781	9.6%
a	4965781	9.6%
n	4577585	8.8%
E	4257355	8.2%
U	4257355	8.2%
F	4257355	8.2%
e	3240558	6.2%
b	3151404	6.1%
y	3151404	6.1%
C	3151404	6.1%
Other values (7)	11924247	23.0%

map_name
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	81.2 MiB

Vya-3 Protectorate	1548995
Cadmium Green	1432638
8 - Badlands_v4	1399496
Niflheim - Final II v2	1343622
Cobalt Valley	1056064
Other values (19)	3868502

Length

Max length	35
Median length	29
Mean length	15.09206299
Min length	5

Characters and Unicode

Total characters	160720163
Distinct characters	47
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Arctic Refuge - FAF version
2nd row	Crossfire Canal - FAF version
3rd row	Crossfire Canal - FAF version
4th row	Crossfire Canal - FAF version
5th row	Crossfire Canal - FAF version

Common Values

Value	Count	Frequency (%)
Vya-3 Protectorate	1548995	14.5%
Cadmium Green	1432638	13.5%
8 - Badlands_v4	1399496	13.1%
Niflheim - Final II v2	1343622	12.6%
Cobalt Valley	1056064	9.9%
Floralis	914347	8.6%
Cloud Kingdom LE	907900	8.5%
Pelagial	743285	7.0%
Loki - FAF version	423028	4.0%
Point of Reach v4	378868	3.6%
Other values (14)	501074	4.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	3336968	11.9%
vya-3	1548995	5.5%
protectorate	1548995	5.5%
green	1432638	5.1%
cadmium	1432638	5.1%
8	1399496	5.0%
badlands_v4	1399496	5.0%
niflheim	1343622	4.8%
final	1343622	4.8%
ii	1343622	4.8%
Other values (40)	11800612	42.2%

Most occurring characters

Value	Count	Frequency (%)
	17281387	10.8%
a	14148705	8.8%
l	11732982	7.3%
e	10654749	6.6%
i	9739124	6.1%
o	8839220	5.5%
r	6608347	4.1%
t	6316215	3.9%
n	6298314	3.9%
d	6115548	3.8%
Other values (37)	62985572	39.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	107089826	66.6%
Uppercase Letter	23960774	14.9%
Space Separator	17281387	10.8%
Decimal Number	6070477	3.8%
Dash Punctuation	4885963	3.0%
Connector Punctuation	1399496	0.9%
Other Punctuation	32240	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	14148705	13.2%
l	11732982	11.0%
e	10654749	9.9%
i	9739124	9.1%
o	8839220	8.3%
r	6608347	6.2%
t	6316215	5.9%
n	6298314	5.9%
d	6115548	5.7%
m	5275351	4.9%
Other values (12)	21361271	19.9%

Uppercase Letter

Value	Count	Frequency (%)
C	3587819	15.0%
F	3497780	14.6%
P	2751449	11.5%
I	2687244	11.2%
V	2605059	10.9%
G	1463198	6.1%
B	1399496	5.8%
N	1343622	5.6%
L	1330928	5.6%
E	980711	4.1%
Other values (7)	2313468	9.7%

Decimal Number

Value	Count	Frequency (%)
4	1778364	29.3%
3	1548995	25.5%
8	1399496	23.1%
2	1343622	22.1%

Space Separator

Value	Count	Frequency (%)
	17281387	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	4885963	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	1399496	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	32240	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	131050600	81.5%
Common	29669563	18.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	14148705	10.8%
l	11732982	9.0%
e	10654749	8.1%
i	9739124	7.4%
o	8839220	6.7%
r	6608347	5.0%
t	6316215	4.8%
n	6298314	4.8%
d	6115548	4.7%
m	5275351	4.0%
Other values (29)	45322045	34.6%

Common

Value	Count	Frequency (%)
	17281387	58.2%
-	4885963	16.5%
4	1778364	6.0%
3	1548995	5.2%
_	1399496	4.7%
8	1399496	4.7%
2	1343622	4.5%
'	32240	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	160720163	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	17281387	10.8%
a	14148705	8.8%
l	11732982	7.3%
e	10654749	6.6%
i	9739124	6.1%
o	8839220	5.5%
r	6608347	4.1%
t	6316215	3.9%
n	6298314	3.9%
d	6115548	3.8%
Other values (37)	62985572	39.2%

map_thumbnail
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	81.2 MiB

https://content.faforever.com/maps/previews/large/scmp_026.png	1548995
https://content.faforever.com/maps/previews/large/cadmium_green.v0001.png	1432638
https://content.faforever.com/maps/previews/large/8 - badlands_v4.v0001.png	1399496
https://content.faforever.com/maps/previews/large/niflheim_-_final_ii_v2.v0002.png	1343622
https://content.faforever.com/maps/previews/large/cobalt valley v1.png	1056064
Other values (19)	3868502

Length

Max length	95
Median length	87
Mean length	72.19683131
Min length	62

Characters and Unicode

Total characters	768846943
Distinct characters	38
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	https://content.faforever.com/maps/previews/large/arctic_refuge_-_faf_version.v0002.png
2nd row	https://content.faforever.com/maps/previews/large/crossfire_canal_-_faf_version.v0002.png
3rd row	https://content.faforever.com/maps/previews/large/crossfire_canal_-_faf_version.v0002.png
4th row	https://content.faforever.com/maps/previews/large/crossfire_canal_-_faf_version.v0002.png
5th row	https://content.faforever.com/maps/previews/large/crossfire_canal_-_faf_version.v0002.png

Common Values

Value	Count	Frequency (%)
https://content.faforever.com/maps/previews/large/scmp_026.png	1548995	14.5%
https://content.faforever.com/maps/previews/large/cadmium_green.v0001.png	1432638	13.5%
https://content.faforever.com/maps/previews/large/8 - badlands_v4.v0001.png	1399496	13.1%
https://content.faforever.com/maps/previews/large/niflheim_-_final_ii_v2.v0002.png	1343622	12.6%
https://content.faforever.com/maps/previews/large/cobalt valley v1.png	1056064	9.9%
https://content.faforever.com/maps/previews/large/floralis.v0003.png	914347	8.6%
https://content.faforever.com/maps/previews/large/cloud_kingdom_le.v0017.png	907900	8.5%
https://content.faforever.com/maps/previews/large/pelagial.v0004.png	743285	7.0%
https://content.faforever.com/maps/previews/large/loki_-_faf_version.v0003.png	423028	4.0%
https://content.faforever.com/maps/previews/large/point of reach v4.png	378868	3.6%
Other values (14)	501074	4.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
https://content.faforever.com/maps/previews/large/scmp_026.png	1548995	9.3%
https://content.faforever.com/maps/previews/large/cadmium_green.v0001.png	1432638	8.6%
https://content.faforever.com/maps/previews/large/8	1399496	8.4%
	1399496	8.4%
badlands_v4.v0001.png	1399496	8.4%
https://content.faforever.com/maps/previews/large/niflheim_-_final_ii_v2.v0002.png	1343622	8.0%
https://content.faforever.com/maps/previews/large/cobalt	1056064	6.3%
valley	1056064	6.3%
v1.png	1056064	6.3%
https://content.faforever.com/maps/previews/large/floralis.v0003.png	914347	5.5%
Other values (22)	4122999	24.6%

Most occurring characters

Value	Count	Frequency (%)
e	72385717	9.4%
/	63895902	8.3%
r	46590364	6.1%
p	45368017	5.9%
t	44310404	5.8%
a	43674052	5.7%
n	39542232	5.1%
.	39533446	5.1%
o	37739301	4.9%
s	36842359	4.8%
Other values (28)	298965149	38.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	590984887	76.9%
Other Punctuation	114078665	14.8%
Decimal Number	40709476	5.3%
Connector Punctuation	13656983	1.8%
Space Separator	6079964	0.8%
Dash Punctuation	3336968	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	72385717	12.2%
r	46590364	7.9%
p	45368017	7.7%
t	44310404	7.5%
a	43674052	7.4%
n	39542232	6.7%
o	37739301	6.4%
s	36842359	6.2%
v	34712093	5.9%
m	28134240	4.8%
Other values (13)	161686108	27.4%

Decimal Number

Value	Count	Frequency (%)
0	23492890	57.7%
1	4980967	12.2%
2	4350016	10.7%
4	2532909	6.2%
6	1548995	3.8%
8	1399496	3.4%
3	1398528	3.4%
7	955555	2.3%
5	50120	0.1%

Other Punctuation

Value	Count	Frequency (%)
/	63895902	56.0%
.	39533446	34.7%
:	10649317	9.3%

Connector Punctuation

Value	Count	Frequency (%)
_	13656983	100.0%

Space Separator

Value	Count	Frequency (%)
	6079964	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3336968	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	590984887	76.9%
Common	177862056	23.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	72385717	12.2%
r	46590364	7.9%
p	45368017	7.7%
t	44310404	7.5%
a	43674052	7.4%
n	39542232	6.7%
o	37739301	6.4%
s	36842359	6.2%
v	34712093	5.9%
m	28134240	4.8%
Other values (13)	161686108	27.4%

Common

Value	Count	Frequency (%)
/	63895902	35.9%
.	39533446	22.2%
0	23492890	13.2%
_	13656983	7.7%
:	10649317	6.0%
	6079964	3.4%
1	4980967	2.8%
2	4350016	2.4%
-	3336968	1.9%
4	2532909	1.4%
Other values (5)	5352694	3.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	768846943	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	72385717	9.4%
/	63895902	8.3%
r	46590364	6.1%
p	45368017	5.9%
t	44310404	5.8%
a	43674052	5.7%
n	39542232	5.1%
.	39533446	5.1%
o	37739301	4.9%
s	36842359	4.8%
Other values (28)	298965149	38.9%

map_width
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	81.2 MiB

512	7489081
256	1908519
1024	1251717

Length

Max length	4
Median length	3
Mean length	3.117539651
Min length	3

Characters and Unicode

Total characters	33199668
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	512
2nd row	1024
3rd row	1024
4th row	1024
5th row	1024

Common Values

Value	Count	Frequency (%)
512	7489081	70.3%
256	1908519	17.9%
1024	1251717	11.8%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
512	7489081	70.3%
256	1908519	17.9%
1024	1251717	11.8%

Most occurring characters

Value	Count	Frequency (%)
2	10649317	32.1%
5	9397600	28.3%
1	8740798	26.3%
6	1908519	5.7%
0	1251717	3.8%
4	1251717	3.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	33199668	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	10649317	32.1%
5	9397600	28.3%
1	8740798	26.3%
6	1908519	5.7%
0	1251717	3.8%
4	1251717	3.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	33199668	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	10649317	32.1%
5	9397600	28.3%
1	8740798	26.3%
6	1908519	5.7%
0	1251717	3.8%
4	1251717	3.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	33199668	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	10649317	32.1%
5	9397600	28.3%
1	8740798	26.3%
6	1908519	5.7%
0	1251717	3.8%
4	1251717	3.8%

map_height
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	81.2 MiB

512	7489081
256	1908519
1024	1251717

Length

Max length	4
Median length	3
Mean length	3.117539651
Min length	3

Characters and Unicode

Total characters	33199668
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	512
2nd row	1024
3rd row	1024
4th row	1024
5th row	1024

Common Values

Value	Count	Frequency (%)
512	7489081	70.3%
256	1908519	17.9%
1024	1251717	11.8%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
512	7489081	70.3%
256	1908519	17.9%
1024	1251717	11.8%

Most occurring characters

Value	Count	Frequency (%)
2	10649317	32.1%
5	9397600	28.3%
1	8740798	26.3%
6	1908519	5.7%
0	1251717	3.8%
4	1251717	3.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	33199668	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	10649317	32.1%
5	9397600	28.3%
1	8740798	26.3%
6	1908519	5.7%
0	1251717	3.8%
4	1251717	3.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	33199668	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	10649317	32.1%
5	9397600	28.3%
1	8740798	26.3%
6	1908519	5.7%
0	1251717	3.8%
4	1251717	3.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	33199668	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	10649317	32.1%
5	9397600	28.3%
1	8740798	26.3%
6	1908519	5.7%
0	1251717	3.8%
4	1251717	3.8%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	id	start_time	offset_ms	player	type	units_number	blueprint	position_x	position_y	command_name	faf_player_id	login	rating	faction	map_name	map_thumbnail	map_width	map_height
0	16630555	2022-03-25 09:22:13 UTC	654500	1	issue	2	NaN	43.933487	126.474571	TransportUnloadSpecificUnits	82362	Exselsior	1527	Cybran	Arctic Refuge - FAF version	https://content.faforever.com/maps/previews/large/arctic_refuge_-_faf_version.v0002.png	512	512
1	16534378	2022-03-11 20:19:06 UTC	993900	0	issue	52	NaN	310.636597	238.775345	FormMove	156219	StormLantern	1776	Cybran	Crossfire Canal - FAF version	https://content.faforever.com/maps/previews/large/crossfire_canal_-_faf_version.v0002.png	1024	1024
2	16553544	2022-03-14 00:27:49 UTC	894900	0	issue	1	NaN	NaN	NaN	Stop	304205	Saphed	1501	Seraphim	Crossfire Canal - FAF version	https://content.faforever.com/maps/previews/large/crossfire_canal_-_faf_version.v0002.png	1024	1024
3	16553544	2022-03-14 00:27:49 UTC	814400	1	issue	1	NaN	NaN	NaN	Stop	287686	demonstreamer666	1552	Cybran	Crossfire Canal - FAF version	https://content.faforever.com/maps/previews/large/crossfire_canal_-_faf_version.v0002.png	1024	1024
4	16650721	2022-03-27 14:52:40 UTC	1988600	0	issue	1	NaN	361.272095	766.394592	TransportUnloadUnits	189718	ZXCCURSED	2216	Seraphim	Crossfire Canal - FAF version	https://content.faforever.com/maps/previews/large/crossfire_canal_-_faf_version.v0002.png	1024	1024
5	16619824	2022-03-23 17:52:00 UTC	1066000	0	issue	1	NaN	295.902222	417.644043	TransportUnloadUnits	33632	silentNoob	1657	Cybran	Arcane	https://content.faforever.com/maps/previews/large/arcane.v0001.png	512	512
6	16508457	2022-03-07 19:16:15 UTC	2367200	0	issue	1	NaN	608.132324	207.912689	TransportUnloadUnits	25711	Swkoll	2107	UEF	Crossfire Canal - FAF version	https://content.faforever.com/maps/previews/large/crossfire_canal_-_faf_version.v0002.png	1024	1024
7	16618249	2022-03-23 13:16:43 UTC	767000	0	issue	4	NaN	68.398933	97.800713	TransportUnloadSpecificUnits	19844	Electrician	1678	UEF	Arcane	https://content.faforever.com/maps/previews/large/arcane.v0001.png	512	512
8	16508457	2022-03-07 19:16:15 UTC	1068000	1	issue	1	NaN	NaN	NaN	Stop	136480	Turinturambar	2075	Seraphim	Crossfire Canal - FAF version	https://content.faforever.com/maps/previews/large/crossfire_canal_-_faf_version.v0002.png	1024	1024
9	16529264	2022-03-11 01:13:06 UTC	1186100	1	issue	29	NaN	344.810486	301.400574	FormMove	82362	Exselsior	1551	Seraphim	Frithen	https://content.faforever.com/maps/previews/large/frithen.v0001.png	512	512

Last rows

	id	start_time	offset_ms	player	type	units_number	blueprint	position_x	position_y	command_name	faf_player_id	login	rating	faction	map_name	map_thumbnail	map_width	map_height
10649307	16468020	2022-03-01 21:54:51 UTC	689600	1	factory_issue	1	NaN	163.107361	196.263565	AggressiveMove	287686	demonstreamer666	1570	Aeon	TAG Craftious Maximus - FAF version	https://content.faforever.com/maps/previews/large/tag_craftious_maximus_-_faf_version.v0004.png	512	512
10649308	16468020	2022-03-01 21:54:51 UTC	1333300	0	issue	2	NaN	24.196953	147.426407	AggressiveMove	119070	Cast_Away	1756	Cybran	TAG Craftious Maximus - FAF version	https://content.faforever.com/maps/previews/large/tag_craftious_maximus_-_faf_version.v0004.png	512	512
10649309	16465285	2022-03-01 14:09:47 UTC	447100	1	issue	3	NaN	330.260834	185.265579	AggressiveMove	174608	MAPTOC	1202	Cybran	TAG Craftious Maximus - FAF version	https://content.faforever.com/maps/previews/large/tag_craftious_maximus_-_faf_version.v0004.png	512	512
10649310	16465285	2022-03-01 14:09:47 UTC	775400	0	issue	2	NaN	329.087463	392.115143	AggressiveMove	304205	Saphed	1468	Cybran	TAG Craftious Maximus - FAF version	https://content.faforever.com/maps/previews/large/tag_craftious_maximus_-_faf_version.v0004.png	512	512
10649311	16465285	2022-03-01 14:09:47 UTC	380000	0	issue	2	NaN	125.346039	375.933350	AggressiveMove	304205	Saphed	1468	Cybran	TAG Craftious Maximus - FAF version	https://content.faforever.com/maps/previews/large/tag_craftious_maximus_-_faf_version.v0004.png	512	512
10649312	16463505	2022-03-01 03:33:37 UTC	743200	1	issue	3	NaN	284.151703	341.428772	AggressiveMove	219084	Conorach	1411	UEF	TAG Craftious Maximus - FAF version	https://content.faforever.com/maps/previews/large/tag_craftious_maximus_-_faf_version.v0004.png	512	512
10649313	16465285	2022-03-01 14:09:47 UTC	793700	0	issue	1	NaN	217.667480	175.959106	AggressiveMove	304205	Saphed	1468	Cybran	TAG Craftious Maximus - FAF version	https://content.faforever.com/maps/previews/large/tag_craftious_maximus_-_faf_version.v0004.png	512	512
10649314	16463505	2022-03-01 03:33:37 UTC	432100	1	issue	1	NaN	354.588531	447.169708	AggressiveMove	219084	Conorach	1411	UEF	TAG Craftious Maximus - FAF version	https://content.faforever.com/maps/previews/large/tag_craftious_maximus_-_faf_version.v0004.png	512	512
10649315	16465285	2022-03-01 14:09:47 UTC	612600	1	issue	2	NaN	418.130646	367.067932	AggressiveMove	174608	MAPTOC	1202	Cybran	TAG Craftious Maximus - FAF version	https://content.faforever.com/maps/previews/large/tag_craftious_maximus_-_faf_version.v0004.png	512	512
10649316	16465285	2022-03-01 14:09:47 UTC	397000	1	factory_issue	1	NaN	283.568237	312.736023	AggressiveMove	174608	MAPTOC	1202	Cybran	TAG Craftious Maximus - FAF version	https://content.faforever.com/maps/previews/large/tag_craftious_maximus_-_faf_version.v0004.png	512	512

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Dash Punctuation

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category